/****** Object:  StoredProcedure [dbo].[sp_KCL_GetAllStaffs]    Script Date: 04/23/2011 21:33:55 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_KCL_GetAllStaffs]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_KCL_GetAllStaffs]
GO

/****** Object:  StoredProcedure [dbo].[sp_KCL_GetAllStaffs]    Script Date: 04/23/2011 21:33:55 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- ==================================================================================
-- Revision History:
-- Date					Author			Description
-- 23-04-2011			btnam			Create script
-- ==================================================================================
CREATE PROCEDURE [dbo].[sp_KCL_GetAllStaffs]
AS
BEGIN
	
	SET NOCOUNT ON;
	
	SELECT *
	FROM [User]
	ORDER BY [id]
	
END

GO


